package com.one.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.one.dto.AqiDistributeTotalStatisDto;
import com.one.dto.AqiTrendTotalStatisDto;
import com.one.dto.ProvinceItemTotalStatisDto;
import com.one.dto.StatisticsPageRequestDto;
import com.one.entity.Statistics;
import org.apache.ibatis.annotations.Mapper;


import java.util.List;
@Mapper
public interface StatisticsMapper extends BaseMapper<Statistics>{

	/********************** nepm工程 *********************/ 
	public int getStatisticsCount(StatisticsPageRequestDto statisticsPageRequestDto);
	public List<Statistics> listStatisticsPage(StatisticsPageRequestDto statisticsPageRequestDto);
	
	public Statistics getStatisticsById(Integer id);
	/********************** nepm工程 *********************/
	
	/********************** nepv工程 *********************/
	//省分组分项检查数据统计
	public List<ProvinceItemTotalStatisDto> listProvinceItemTotalStatis();
	//按年省分组分项检查数据统计
	public List<ProvinceItemTotalStatisDto> listProvinceTotalStatisByYear(String year);
	//按年省分组分项（空气质量差）检查数据统计
	public List<ProvinceItemTotalStatisDto> listProvinceBadTotalStatisByYear(String year);
	//AQI控股权指数指数级别分布统计
	public List<AqiDistributeTotalStatisDto> listAqiDistributeTotalStatis();
	//十二个月AQI超标趋势统计
	public List<AqiTrendTotalStatisDto> listAqiTrendTotalStatis(List<AqiTrendTotalStatisDto> list);

	/********************** nepv工程 *********************/
}
